from config import file_url_config, query_params_config

server = "192.168.3.38"
database = 'KingboxQXW1'
username = 'zzfj'
password = 'zzfj'
conn_str = f'DRIVER={{SQL Server}};SERVER={server};DATABASE={database};UID={username};PWD={password}'

# 查询的日期
yesterday = query_params_config.yesterday
nowDay = query_params_config.nowDay
# 查询开始时间
query_start_time = query_params_config.query_start_time
# 查询结束时间
query_end_time = query_params_config.query_end_time

id_prefix = 'jinbo'
data_source = '众志---金博'

selenium_file_prefix = f'{file_url_config.download_selenium_excel_file_prefix_url}\\{nowDay}'
clean_file_prefix = f'{file_url_config.download_excel_file_prefix_url}\\{nowDay}'

jinbo_excel_name = "金博销售数据.xlsx"
jinbo_error_file_url = f'{selenium_file_prefix}\\金博销售数据导出失败.txt'
excel_file_url = f'{clean_file_prefix}\\{jinbo_excel_name}'